package com.it.reggie.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.it.reggie.entity.Category;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author:cyh
 * @data:2022/12/15 9:54
 */
@Mapper
public interface CategoryDao extends BaseMapper<Category> {
    @Select("select count(*) from dish where category_id=#{id}")
    int queryDishById(Long id);

    @Select("select count(*) from setmeal where category_id=#{id}")
    int querySetmealById(Long id);
}
